SELECT Id FROM new_searchtable
where (town like 'Lyme' or town like 'Enfield' or town like 'Plainfield' or town like 'Cornish') and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley NH Homes page 25
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Charming 1949 lakeside ranch offers a rare blend of classic character just steps from Crystal Lake—known for its clear waters, recreation, and year-round beauty. Set directly across the street from the lake, the home is paired with an additional attached parcel on the water. Inside, the home features three bedrooms and two baths, with a warm, functional layout that reflects its mid-century roots. A partially finished basement adds valuable flexible space—ideal for a family room, home office, or guest overflow. Large windows invite in natural light, while the setting provides stunning lake views and a peaceful atmosphere.
Description:Timeless 1820 Brick Colonial on 15 Stunning Acres. Step back in time while enjoying modern comfort in this beautifully maintained 1820 classic brick Colonial set on 15 picturesque acres of open fields. Rich with historic charm and character, this exceptional property features wood floors, elegant crown molding, and multiple fireplaces that create warmth and sophistication throughout. The spacious main home offers gracious living areas filled with natural light and period details, perfect for gathering and entertaining. A separate in-law apartment provides flexibility for extended family, guests, rental income, or a private home office. Outside, the possibilities are endless with a large traditional barn, two separate garages, and expansive open land ideal for gardening, horses, farming, recreation, or simply enjoying the beauty and privacy of the countryside. This rare offering combines historic craftsmanship, versatile living space, and breathtaking acreage—a property with endless potential and timeless appeal.
Description:Experience the timeless charm of this classic 1903 Victorian with a beautiful carriage shed, ideally situated on a generous half-acre lot just minutes from the heart of Enfield and a short drive to Mascoma Lake. Rich in character and architectural detail, this four-bedroom, one-and-a-half-bath home has beautiful wood floors throughout, soaring ceilings, an elegant staircase with a stunning stained-glass window, a living room with fireplace and a formal dining room perfect for entertaining. The third floor offers unique additional space featuring beautiful wainscoted ceiling and walls and period charm. Outside, a carriage shed provides endless possibilities for storage, hobbies, or workshop space or convert into living space! Conveniently located walking distance to town for coffee or dinner or hop on the rail trail just a block away! Don't miss the grand home! Super location just 20 mins to Dartmouth Health! Showings by appointment.
Description:Own a piece of early New England history with waterfront — a rare combination that almost never comes available. This iconic 1812 stone home sits on a level 0.98-acre lot and includes 130 feet of owned Connecticut River frontage just across the quiet country road, offering easy access for kayaking, fishing, paddle boarding, or simply enjoying the ever-changing water views. Inside, the home blends historic character with comfortable living. The first floor offers a warm and inviting living room with wood stove, country kitchen with dining nook, formal dining room, first-floor bedroom, half bath, sun porch, workshop space, and generous storage. Upstairs you'll find a large primary bedroom, office, and full bath, while the third level provides an additional bedroom and flexible bonus space perfect for guests, studio, or work-from-home use. Original details remain throughout — maple floors on the main level, wide pine floors above, and deep farmhouse window trim — creating the charm only a true period home can offer. Outside, the property is equally special, with mature landscaping, established garden areas, patio space, and a workshop/shed. The river frontage across the road expands the lifestyle, giving you your own personal access to the Connecticut River without sacrificing privacy at the house site. Conveniently located just minutes to I-91 and an easy bike ride to Post Pond and Cedar Circle Farm, this property offers a unique blend of history, recreation, and rural tranquility — a setting increasingly difficult to find in the Upper Valley. Just a 20 minute drive to downtown Hanover & Dartmouth College. High School Choice.
Description:Surrounded by the landscapes that inspired generations of artists in the former Cornish Art Colony, where grand old homes from another era keep watch, sits a homestead that has been lovingly and extensively restored by the current owners. The interior is a complete, custom renovation, with all the charm. It feels like the farmhouse you've been picturing for years: wide pine floors underfoot, post-and-beam bones overhead, and vertical nickel-gap shiplap that adds warmth and dimension. At the center of it all is a custom kitchen built around the idea that the best nights happen when everyone crowds in. Source a big farmhouse table for friends and family to gather around and let dinner take its time. One-level living comes easy with a main-floor bedroom and full bath, while upstairs two more bedrooms share a renovated bath with walk-in shower and claw-foot tub for long soaks. When the weather turns, the Jotul woodstove does what a woodstove should - pulls the whole house in close, while you watch the snow fall outside. The storied barn anchors the home's ell and welcomes you to the mudroom. Tucked away at the end of the ell is a simple studio space - a place that invites imagination, whether envisioned as a workshop, a creative haven, or private guest quarters apart from the main home. Outside, the landscape unfolds with a sense of abundance. Mornings begin on the covered deck with coffee in hand and the sound of the Blow-Me-Down Brook winding its way along the property's edge. On warm summer days, a beloved swimming hole offers a refreshing escape, while the historic Blow-Me-Down Covered Bridge stands as a timeless backdrop to daily life. For those drawn to hiking, the Top-of-the-World trails just up the road offer scenic views of Ascutney. A chicken coop, garden space, fruit trees, and acres of tillable field offer the opportunity to cultivate a more connected way of living.